UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qnXkZngbDxp86M6K9QB2nCtlKPSCOrvvWd5tRhqgMo='
WHERE
key_id = 'ae38911a0d47fa8ad222b6b8e3edd16986de289f7871f58a36395be62b7ae7cf'
AND (
token = '6qnXkZngbDxp86M6K9QB2nCtlKPSCOrvvWd5tRhqgMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)