UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hN4KT9A26XSYQowGyYCVZusqye2qUVepcv71zkr/Kdw='
WHERE
key_id = '3bd7b8e8c3137864e15aabbc94ff578477bd012e29b2c0b0a77998be4f7b732b'
AND (
token = 'hN4KT9A26XSYQowGyYCVZusqye2qUVepcv71zkr/Kdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)