UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9uLKv2BGwME4q+3Bw22cTAGNTA0d6MXmur153WTNdbc=' 
WHERE 
  key_id = 'be80f4261580676a8c1c08edc0ae9d223c9f23a7b403fd39f02c55c73dbdf920' 
  AND (
    token = '9uLKv2BGwME4q+3Bw22cTAGNTA0d6MXmur153WTNdbc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021