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