UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wLKPQ/pPCfG2pjLUI6TcXAupBJyhm6uN6kPUr6E/SqQ='
WHERE
key_id = 'b04ec4dff84c411cf31d83e478c604cd574f540c8b1155627c0792ab87957963'
AND (
token = 'wLKPQ/pPCfG2pjLUI6TcXAupBJyhm6uN6kPUr6E/SqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)