UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lZ1P8DIx/3Y3DqOEg/uELRXPZ4uk2nG9PRq+gg0UTec=' 
WHERE 
  key_id = '95e715464f5988b1297485888a7545a28c1dfd54dcf0e777da1d9608cd97ee45' 
  AND (
    token = 'lZ1P8DIx/3Y3DqOEg/uELRXPZ4uk2nG9PRq+gg0UTec=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031