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

Query time 0.00030