UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9+rjk8QbWBgvN6+nk7sebfkw8lrEVXsZdhAT7hnAxQ='
WHERE
key_id = 'de947c3b9b002fc2ab933bc98ec65a07748c0fdf53af254eb32e4438dc864d79'
AND (
token = 'D9+rjk8QbWBgvN6+nk7sebfkw8lrEVXsZdhAT7hnAxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)