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