UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AvEFghBAcv3RL+lY+ilXOO6s17zUtWwnWXx2oLtmHWw='
WHERE
key_id = '8ec6741f0d646481fd2f613513cee64b0cc385b86a561957033bdb4f9ecb0b96'
AND (
token = 'AvEFghBAcv3RL+lY+ilXOO6s17zUtWwnWXx2oLtmHWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)