UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XKVbvJXhD5QZfrUMNYnw5MwAuGoXNsgAvzW8wOFPusA='
WHERE
key_id = '66d0c9ea8f1a23fead44a729ba975c7288a0da1d953d77ebe4252986ca671b8a'
AND (
token = 'XKVbvJXhD5QZfrUMNYnw5MwAuGoXNsgAvzW8wOFPusA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)