UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A6nk6PBjdgVjXVjNYPoawcWr0CwbyR6wHyxeTjwh47s='
WHERE
key_id = 'a295dacb09df5bf84552095a677b816e965fbf3527a38488e5fa1b371be029ed'
AND (
token = 'A6nk6PBjdgVjXVjNYPoawcWr0CwbyR6wHyxeTjwh47s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)