UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWqMJEjlR1loMRxjlru0nRdztgBKDeg09ARoPAcAKEA='
WHERE
key_id = '7e99929638d9c68607320d98972206447f2d1304bafb9fd5e90d1812314b6f2f'
AND (
token = 'zWqMJEjlR1loMRxjlru0nRdztgBKDeg09ARoPAcAKEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)