UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lWs5B74jGF7/uDDx/CJjtzNK6KA0yJ7hUIRrTxnXkE='
WHERE
key_id = 'ce934e644b4bb18f215e730cfec585886442b58f245b2bb68173d3bdf80958fa'
AND (
token = '8lWs5B74jGF7/uDDx/CJjtzNK6KA0yJ7hUIRrTxnXkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)