UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q4zhiDr5Z3uy09K4y2HmDWvNOgnzSnuWNF/cA3w4Xts='
WHERE
key_id = 'f47ca131224aa8966047e4f5579e716be98f29957e11b7e3af914c6d850adeb7'
AND (
token = 'Q4zhiDr5Z3uy09K4y2HmDWvNOgnzSnuWNF/cA3w4Xts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)