UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/uQh9vvG+pZZIShaehw807zbYGKjf08pVyU9t+71SLM=' 
WHERE 
  key_id = '8daa9c18c861c5dc2ce227dbd9117353b92ea4eb78fd0fc81eea6bcd0de29bc7' 
  AND (
    token = '/uQh9vvG+pZZIShaehw807zbYGKjf08pVyU9t+71SLM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037