UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgBDC6brs5s0w5g93OUet36s8dVWKtnB7/OtLAoViC4='
WHERE
key_id = '037d6e29347ec2a582203b270627cba70c3af38b36fd2045fb114820afbb2ebc'
AND (
token = 'zgBDC6brs5s0w5g93OUet36s8dVWKtnB7/OtLAoViC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)