UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cQTw1GHUjft5SO1jkvacwfXBzM8oaxJfoyujTqVj2b0='
WHERE
key_id = '0137f72c187760f9d0f1d8a9545baef79ed0a3950e4a29a8898f86c9f87ed455'
AND (
token = 'cQTw1GHUjft5SO1jkvacwfXBzM8oaxJfoyujTqVj2b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)