UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgVeBSXwOO8tYLMn8MAg1gJ2l9tYmZbgAwUNqMMWSCw='
WHERE
key_id = '3698dc393f0d6c1d1e81b55f3f4b0edae8b186f3ff8df37a25b813c571631b4e'
AND (
token = 'CgVeBSXwOO8tYLMn8MAg1gJ2l9tYmZbgAwUNqMMWSCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)