UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MhLtduaDwqbQJwCpK/kB0g/C4+lx0rGgYB48infVZVw='
WHERE
key_id = 'a0380a9b51d22f7588d8baa844e951aaaef79e11ec867266268e5b763df72adc'
AND (
token = 'MhLtduaDwqbQJwCpK/kB0g/C4+lx0rGgYB48infVZVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)