UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VFRx1BsxHKxEN2UHV5orvm27E5QduEpQ1cFQA9D6yg='
WHERE
key_id = '47012fa2c31ed1b501740fd63143385cf35009297e35fdab53dd62f872a33755'
AND (
token = '3VFRx1BsxHKxEN2UHV5orvm27E5QduEpQ1cFQA9D6yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)