UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CRdYjh30QdL7tfQDY7FiizXbYLA+wFyk+dqTUP/0Fv8='
WHERE
key_id = 'bac058098b3c6759a87ee1b3087c14dab5746c711ee8f079b5f21ae918df2bf4'
AND (
token = 'CRdYjh30QdL7tfQDY7FiizXbYLA+wFyk+dqTUP/0Fv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)