UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7+3tq5wOBh+0i0WTKuI5QorfweacB7qXvRWgjgMhY8o='
WHERE
key_id = 'bc8445370d3ba664ba5ea6c19a0ac6322bb1cc0b238e1d8a6945dfa5f5ec7097'
AND (
token = '7+3tq5wOBh+0i0WTKuI5QorfweacB7qXvRWgjgMhY8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)