UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g0d1Aai6/guyYbhzxEaP9ZCX279YAb2beGRnYOEuYPg='
WHERE
key_id = 'a11aeb04f9fd50a0f66e82d27c764a419f3b33a4473086d0ffb80a6e7a84655f'
AND (
token = 'g0d1Aai6/guyYbhzxEaP9ZCX279YAb2beGRnYOEuYPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)