UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mCenzVAPQ8Lw45vg0WULpqCq3J2XAaNJRqz37Yz663c='
WHERE
key_id = '00e18438bb2f65c06c2c6186952a52df43329a228d43639423225eb72328b7f7'
AND (
token = 'mCenzVAPQ8Lw45vg0WULpqCq3J2XAaNJRqz37Yz663c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)