UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNl4CwhZs2vuuYPvs8GmToQxl1Wr8/b9p9apLylfjuI='
WHERE
key_id = 'a7a3a5a9a0a7e1fc0fd416c2f12b5aa8c5c511c4340fa572b0ac52e931b3cc9e'
AND (
token = 'QNl4CwhZs2vuuYPvs8GmToQxl1Wr8/b9p9apLylfjuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)