UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0DcgmTOxu0h2jg6MUGDjBuHfd63qX0ZSxef2dh/LXP4='
WHERE
key_id = '7a12e2a93b9cfb60bcc5ced562cede99f45481dd62328182c14cf554b5b65665'
AND (
token = '0DcgmTOxu0h2jg6MUGDjBuHfd63qX0ZSxef2dh/LXP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)