UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0uggfJrM8NHkjA30Z9b5sIyTdLEmn0b1sYjZD1gRzVE='
WHERE
key_id = '394cf4b4c7a3b734dd1fd660df393e598b2345997a0565f1a86b1a1e7927a0cb'
AND (
token = '0uggfJrM8NHkjA30Z9b5sIyTdLEmn0b1sYjZD1gRzVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)