UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UcTKF7Ds+/b+9cRhODZk++Inkso9Exfqf3j3WlfKrBk='
WHERE
key_id = 'e0fd62f85185819c1f66ec502c1c07985ad84e3c03e952b08d932193587a6ad1'
AND (
token = 'UcTKF7Ds+/b+9cRhODZk++Inkso9Exfqf3j3WlfKrBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)