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