UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gDs9cINbpzao9CwEUXWKI4O5jUdhRC8YIsSh2YC8kno='
WHERE
key_id = '8ac97fc2a1fd4d4feb6bedf6580d8a6e1382c2ab45cf22d855a04ec0af7ed4be'
AND (
token = 'gDs9cINbpzao9CwEUXWKI4O5jUdhRC8YIsSh2YC8kno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)