UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jXt6itj3Umx0eoctEqq+PK9dQM0InhIKJWWqwHIFVzM='
WHERE
key_id = '5c2df08d8ec435df622088a9bbf667bd6bf1eca0fb28c68b9e06b8e206eb1395'
AND (
token = 'jXt6itj3Umx0eoctEqq+PK9dQM0InhIKJWWqwHIFVzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)