UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YvXNLgIAcJYaySoC4FDB+8JQO/i7XvId8nF8TqViIg4='
WHERE
key_id = '65e77efaa2727b57e721a10ecd3eceb5975365b33aabb1643c2f1b075a5223c0'
AND (
token = 'YvXNLgIAcJYaySoC4FDB+8JQO/i7XvId8nF8TqViIg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)