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