UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMQYxoF07a1H8FiHx9ce7KBO2n0digl1gFRRJi1SCIo='
WHERE
key_id = 'e4674fc14a26b8f24e13ea2f6558c9e91d564cb6acebd69af27e44465743a30e'
AND (
token = 'ZMQYxoF07a1H8FiHx9ce7KBO2n0digl1gFRRJi1SCIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)