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