UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTpqnYQlZnUeBoqOzN2ZowS/1T6U9VX9rCxfv3jiyO0='
WHERE
key_id = 'b5294755f3250be01910aa1479b5f7087685ac699ab0d8f2ad95e9f85fa91491'
AND (
token = 'sTpqnYQlZnUeBoqOzN2ZowS/1T6U9VX9rCxfv3jiyO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)